-
Re: Copy and Pasting Multiple Rows from Excel into One Multi Dropdown Select Cell in Smartsheet
Use a CHAR(10) delimiter. This is a line break and is the default delimiter in a multi-select dropdown type column which means pasting the values into a cell with line breaks between the selections s…1 · -
Re: "No data to display" on 0% Chart
In all of your formulas that you are using to generate the numbers, add 0.0001 and then decrease the shown decimal places back to none shown. This will display zero, but since technically there is so…2 · -
Re: Bridge - Auto Delete Newly Added Columns
You can avoid using junctions in the Child workflow if you use a List Columns module to get the columns from the target sheet. This lists them out in order from left to right which means that you can…1 · -
Re: Dates are formatting in 2 different ways on the same sheet
Quick note on the zero filling to make the day and month numbers two digits. RIGHT("0" + DAY([LATEST DATES / TIMES]6), 2) will completely replace the IF statement and both outputs you curre…1 · -
Re: Index Collect Simplification
Can you describe what the intent of the formula is? Based on how I am reading it, that is about as efficient as it gets to generate what I see as the output.1 ·